﻿CREATE TABLE [dbo].[Passenger]
(
	Id int NOT NULL CONSTRAINT PK_Passenger PRIMARY KEY IDENTITY (1,1), 
	Name nvarchar(40) NOT NULL,
	Surname nvarchar(40) NOT NULL,
	Title int NOT NULL CONSTRAINT FK_Passenger_Title REFERENCES Title(Id),
	Email nvarchar(50),
	Phone nvarchar(20) NOT NULL,
	DocumentType int CONSTRAINT FK_Passenger_DocumentTYpe REFERENCES DocumentType(Id),
	DocumentNumber nvarchar(15),
	DOB DateTime,
	PassengerType int NOT NULL CONSTRAINT FK_Passenger_PassengerType REFERENCES PassengerType(Id),
	[Address] nvarchar(200)
)